Microsoft the cells actually got a couple of different layers of protection that you can add to content
.
Earlier we took a look at protecting cells within a worksheet.
Couple of steps you got to go through.
Now I want to show off how you can protect an entire workbook.
Not really the contents necessarily within the workbook but the structure of the workbook.
Once you think about this in the outside of this example file that I have open in front of you I've
got this work she called the watch window and on this worksheet I've got a cell cell BE2 has a simple
little formula in it nothing big but this formula references another worksheets it references it by
its name formula auditing right there.
Well what happens if somebody renames that worksheet or deletes that worksheets.
What if you had multiple formulas that referenced multiple worksheets and they got people that are messing
all around with the worksheets their names or deleting them and now what happens.
Your formulas right there.
They're now broken because that data is gone it's missing a can't find it.
Let's take a look at a feature here called Protect workbook and this is a really simple feature.
Take a look.
I'm going to go to my Review tab.
I'm going to go and read the changes section and just to the right of protect sheet you've got protect
workbook.
I'll give that a click.
Now inside of 2013 2016 you've got a single option structure.
If you're in 2010 of Excel or earlier you've also got windows.
It's the lesser of the two.
It's the lesser used option.
I'm in 2013 so it's not an option for me here.
Now I'm going to keep structure turned on.
I'll put in a password just for demonstration I'll use password as my password.
I'll hit OK.
Asked me to confirm the password.
Make sure you don't lose this caution if you lose or forget the password it cannot be recovered.
Oh OK.
And I've now protected the work book structure.
Now what did you do.
Look I did very much right.
Mirror This is the work book.
Take a look.
Now typically if I come down to a worksheet tab if I want to rename this I'll give it a double click
click click and the Workbook protected cannot be changed.
If I right click on a tab what I could use to do is add worksheets delete worksheet rename or achieve
move worksheets.
I can't do any of that now.
I'm now protecting the structure of the workbook itself.
This will ensure that people aren't renaming deleting stuff that I need within this workbook.
You've nailed it down it's final Don't touch right.
Hands off.
There's the data you can work with that but don't change the structure.
One button press it's up on your Review tab.
Protect the workbook and your goal then that's simple.
Now if you want to reverse the process right I know I want to build to get back in there and add new
worksheets or rename stuff and modify formulas.
Well great no problem.
As long as you have the password back to review click unprotect workbook.
Got to have the password drop that back in there.
I'm now unprotected the workbook.
If I write for Khattab I can now do all of those standard operations.
So a couple levels you can protect the sheet itself and in this case you can protect the structure of
a workbook.
Try this out one button press.
Get your password in there.
Don't forget the password protect your workbook